How to: Use AutoFilter with Top Ten.

Solution:


Select 'Filter' from the 'Data' menu and select 'AutoFilter'. Click the down arrow button in the column where filtering criteria should be entered. Select '(Top Ten...)' from the drop-down list and specify the desired criteria in the 'Top Ten AutoFilter' dialog box.

NOTE: AutoFilter with Top Ten works only for fields that hold numbers.